package com.sannu.emc.utils;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.sannu.emc.db.DbManager;

public class DropDownData {
	
	/*public List<String> getItems() {
        List<String> list = new ArrayList<String>();
        list.add("Thing1");
        list.add("Thing2");
        list.add("Thing3");
        return list;
    }*/

	public List<String> getState() {
		List<String> stateList = new ArrayList<String>();
		ResultSet stateRs = new DbManager().select("select * from state");
		try {
			while(stateRs.next()){
				stateList.add(stateRs.getString(2));
			}
			return stateList;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
}
